C:/Projekte/RAIS/Rais32UpdateTool/MainForm.cs

Go to the documentation of this file.

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Data.SqlClient;
using System.Diagnostics;
using System.Drawing;
using System.IO;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Xml;
using System.Threading; 
using FillCustomQueryTableCL;

namespace RAISInstall
{
    public partial class MainForm : Form
    {
        private string sqlConnection;
        
        delegate void UpdateStatusDelegate(string text);

        public MainForm()
        {
            InitializeComponent();

                        // Set initial values
                        sqlServerTextBox.Text = @"localhost\SQLEXPRESS2008";
                        sqlCatalogTextBox.Text = "RAIS_32";
        }

        
        private void button3_Click(object sender, EventArgs e)
        {
                        tbStatus.Clear();

            string errorString="";
            //if ((passTextBox.Text == "") && (!cbIntegratedSecurity.Checked))
            //    errorString = "Enter User password";
            //if ((loginTextBox.Text == "") && (!cbIntegratedSecurity.Checked))
            //    errorString = "Enter User login";
            if (sqlCatalogTextBox.Text == "")
                errorString = "Enter SQL Server catalog";
                        if (sqlServerTextBox.Text == "")
                                errorString = "Enter SQL Server name";
                        
                        if (errorString == "")
            {
                string sqlConnectionFormat = "Data Source={0};Initial Catalog={1};Integrated Security=True;";
                //string sqlConnectionFormat;
                //if (cbIntegratedSecurity.Checked)
                //{
                    //sqlConnectionFormat = "Data Source={0};Initial Catalog={1};Integrated Security=True;";
                    sqlConnection = string.Format(sqlConnectionFormat, sqlServerTextBox.Text, sqlCatalogTextBox.Text);
                //}
                //else
                //{
                //    sqlConnectionFormat = "Data Source={0};Initial Catalog={1};Integrated Security=False;User ID={2};Password={3};";
                //    sqlConnection = string.Format(sqlConnectionFormat, sqlServerTextBox.Text, sqlCatalogTextBox.Text, loginTextBox.Text, passTextBox.Text);
                //}
                // accessConnection = string.Format(accessConnectionFormat, mdbFileName.Text, mdwFileName.Text, creatorLoginTextbox.Text, creatorPassTextbox.Text);
                tbStatus.Focus();
                Thread migrationProcess = new Thread(new ThreadStart(this.MigrationProcess));
                migrationProcess.Start();
                tbStatus.Focus();
            }
            else
            tbStatus.AppendText(errorString);
                }

        private void UpdateStatusBox(string text)
        {
            tbStatus.AppendText(text);
            tbStatus.Refresh();
        }

        private void UpdateStatus(string text)
        {
            this.Invoke(new UpdateStatusDelegate(UpdateStatusBox), new object[] { text });
        }

        private void MigrationProcess()
        {
            string errorString = "";
            try
            {
                UpdateStatus("Update process started...");

                UpdateStatus("\r\nRAIS 3.1 to 3.2 DB update scripts started...");
                ExecProcess(Application.StartupPath + @"\..\..\..\RAIS_DB\", "UpdateRais31ToRais32.cmd", sqlServerTextBox.Text + " " + sqlCatalogTextBox.Text);
                UpdateStatus("\r\nRAIS 3.1 to 3.2 update scripts finished");

                UpdateStatus("\r\nQuery table is being filled...");
                string queriesFileName = Application.StartupPath + @"\..\..\..\RAIS_DB\RAIS32 Update Scripts\Rais32Queries.xml";
                QueryTable.FillQueryTable(sqlConnection, queriesFileName);
                UpdateStatus("\r\nQuery table has been filled.");

                UpdateStatus("\r\n\r\nUpdate has been finished.");

            }
            catch (Exception ex)
            {
                errorString = ex.Message;
                if (ex is SqlException)
                {
                    UpdateStatus("\r\nConnection to MS SQL Server failed...");
                }
                UpdateStatus("\r\n" + errorString);
                UpdateStatus("\r\nUpdate process aborted with error");
            }
        }

       
                private static int ExecProcess(string strWorkingDirectory, string strExePath, string strArguments)
                {
                        Process prcStsadmin = new Process();
                        prcStsadmin.StartInfo.FileName = strExePath;
                        prcStsadmin.StartInfo.WorkingDirectory = strWorkingDirectory;
                        prcStsadmin.StartInfo.UseShellExecute = true;
                        prcStsadmin.StartInfo.RedirectStandardOutput = false;
                        prcStsadmin.StartInfo.WindowStyle = ProcessWindowStyle.Normal;
                        prcStsadmin.StartInfo.Arguments = strArguments;
                        prcStsadmin.StartInfo.CreateNoWindow = false;

                        prcStsadmin.Start();
                        prcStsadmin.WaitForExit();
                        return prcStsadmin.ExitCode;
                }

        private void cbIntegratedSecurity_CheckedChanged(object sender, EventArgs e)
        {
            loginTextBox.Enabled = !cbIntegratedSecurity.Checked;
            passTextBox.Enabled = !cbIntegratedSecurity.Checked;
            label5.Enabled = !cbIntegratedSecurity.Checked;
            label6.Enabled = !cbIntegratedSecurity.Checked;
        }
    }
}